All Questions
70 questions
0votes
0answers
59views
Install mysql (not mariadb) on raspbian bookworm and other debian
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter)...
- 101
0votes
0answers
82views
single node Slurm machine, munge authentication problem
I'm in the process of setting up a singe-node Slurm workstation machine and I believe I followed the process closely and everything is working just fine. See below: sudo systemctl restart slurmdbd &...
- 199
-1votes
1answer
85views
Can ClamAV detect malicious files on a MySQL/MariaDB server?
Can ClamAV help detect malicious files (ie malware, rootkits, etc) for a MySQL/MariaDB server, specifically the /var/lib/mysql data folder? The database server is a single role and locked down both by ...
0votes
0answers
21views
Capturing Data from Sensors Sequentially Using Raspberry Pi 5 and NRF24
I am developing a project on Raspberry Pi 5. For this project, I have 6 sensors and I collect data from these sensors. I use NRF24 when collecting data. I store the data I collect in the database I ...
- 1
0votes
0answers
70views
Mysql server under pressure?
I'm having issue with a server than hosting 5 Wordpress and 1 staging Including on Woocommerce and one Bbpress with huge db. The server got 120Go Ram with 500Mo swap set. I have a TTFB around 3s... ...
0votes
2answers
529views
Why do we misnomer MariaDB as a "mysql-server"?
I've had an interesting discussion recently, about whether it is okay to call MariaDB a "mysql server" when in reality, Maria is not 100% compatible with MySQL. I understand it was ...
- 53
0votes
0answers
1kviews
mariadb service not found in centos 8
On a Centos 8 server I'm trying to install MariaDB and MySQL. I have used this command dnf install mariadb-server mariadb -y mysql-community-server-5.7.40-1.el7.x86_64 was installed after that. Now, ...
0votes
1answer
762views
how execute curl in mariadb/mysql stored procedure
I am using information from here and here. I am running mariadb server on Debian 10. I download and copied the files to the server and execute the install.sh and I get the following error below. &...
2votes
2answers
4kviews
MariaDB & Amazon Linux 2: ERROR: ld.so: object '/usr/lib64/libjemalloc.so.1' from LD_PRELOAD cannot be preloaded
Following AWS documents, I'm attempting to get a basic LAMP server up and running. Everything appears to be working fine. Logging into MySQL either through the terminal or phpMyAdmin (GUI) works. ...
0votes
1answer
300views
Can't restart MariaDB after adding datadir line to my.cnf file
Having a issue getting MariaDB to restart after adding the following line to the [mysqld] section of my.cnf: datadir = /home/mysql It won't restart. Could this be a permissions issue. This is the ...
0votes
1answer
124views
Free up mysql space on low-disk PC
I have a PC with a small disk: Filesystem Size Used Avail Use% Mounted on /dev/root 3.5G 3.1G 249M 93% / devtmpfs 459M 0 459M 0% /dev tmpfs 463M 0 463M 0% ...
- 1,303
-1votes
1answer
171views
mysql on artix linux gives the 'ERROR 2002 (HY000)'
I'm using artix linux with runit init system and I've stumbled upon this issue where I can't login into mariadb by using sudo mysql -u root -p because it gives me the following error: ERROR 2002 (...
- 41
1vote
0answers
170views
Dovecot - password query syntax error
Whenever Thunderbird attempts to connect to my server I receive an error in the maillog of dovecot: auth-worker(32527): Error: sql(admin,xxx.xxx.xxx.xxx,): Password query failed: You have an error in ...
- 11
1vote
1answer
1kviews
start mysql/mariaDB service after datadir change
I installed the mariadb server and create a root user with a password with sudo apt install mariadb-server sudo mysql_secure_installation Since I use a Rasperri Pi I want to swap the DB to an ...
- 113
1vote
1answer
875views
How to query mysql from cron script?
I have the following code in my script: mapfile results < <(mysql --batch -u $DB_USERNAME -p$DB_PASSWORD $DB_DATABASE < query.sql) and it works fine if running from command line. But if ...
- 3,375
